﻿using System;

namespace edowork.com.Model
{
    #region creditInfo

    [Serializable]
    public class creditInfo
    {
        #region Private fields

        protected string _creditid = String.Empty;
        protected string _creditname = String.Empty;
        protected decimal _creditqty;
        protected string _sysdate = String.Empty;

        #endregion

        public creditInfo() { }

        #region Public Properties

        public string Creditid
        {
            get { return _creditid; }
            set { _creditid = value; }
        }

        public string Creditname
        {
            get { return _creditname; }
            set { _creditname = value; }
        }

        public decimal Creditqty
        {
            get { return _creditqty; }
            set { _creditqty = value; }
        }

        public string Sysdate
        {
            get { return _sysdate; }
            set { _sysdate = value; }
        }

        #endregion

        #region Public SQL Script

        public string SQL_Insert()
        {
            return "insert into credit(Creditid,Creditname,Creditqty,Sysdate) values('{0}','{1}',{2},'{3}')";
        }

        #endregion

    }

    #endregion
}

